|
/
More
|
|
/
More
|
The product hierarchy is a tree structure that is made of up to 10 levels. This allows you to set up a breakdown of departments, product groups and stock items available for sale by the company.
You must import a CSVComma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. file to create this tree structure. Each row in the CSV file represents a branch of the hierarchy.
The first row contains the names of the levels. The final column is assumed to represent the Product Group level. Therefore there is a maximum of 9 columns.
The Stock Item level will be added automatically.
Every other row in the file represents a single item in the product hierarchy. They are ordered as they would be when the product hierarchy is fully expanded in the application. Therefore, each item each line must be followed by all of the sub-items relating to that line.
For example:
| Department | Sub-Department | Product Group |
|---|---|---|
| Clothing | Menswear | JEAN1 |
| Clothing | Menswear | SHIRT1 |
| Clothing | Ladies wear | SKIRT1 |
| Electricals | DVD | DVD_RW1 |
The final level should be filled with the product group codes from the Stock Control module. The import process will move these product groups into the final hierarchy.
When a Product Group is imported from Sage 200 into the hierarchy, any associated stock items in that group will be imported as a standard stock item.
The conversion to variants is done at a later stage of the import process.
Open: Retail > Data Migration > Product Hierarchy.
Enter the name of the CSVComma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. file you want to import in the Source File box, or use the browse button to select the file.
To check the contents of the CSV file, click Validate.
This checks that each line of data in the CSV file is correct. For example, it will make sure that there are no missing values or invalid product groups. Any invalid data will be reported on-screen.
To save the details as a text file by click Save Log once the data validation has finished.
To transfer the product group and stock data from your CSV file, click Import. This:
Checks if a hierarchy already exists (i.e. you are importing into an existing hierarchy).
If the hierarchy exists, the headings on the first line of the CSV file must match the current hierarchy detailed in the RTLPrdLevel table.
If no hierarchy exists, the current hierarchy definition is deleted and a new one is created. The headings in the new hierarchy are based on the details in the first line of the CSV file (RTLPrdLevel).